﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace migradorWPF.Base
{
    public static class Constantes
    {
        public static class BasesDeDatosSoportadas
        {
            public const string SQL_SERVER = "SQL Server 2005+";
            public const string POSTGRESQL = "PostgreSQL 8x+";
            public const string Oracle10g11g = "Oracle 10g - 11g";
            public const string Mysql5x = "Mysql 5x";
        }

        public static class StringDeConeccion
        {
            public const string SQL_SERVER = "Database={2};Server={0},{1};User={3};Password={4};Connection Timeout=10";
            public const string POSTGRESQL = "Server={0};Port={1};Database={2};User Id={3};Password={4};";
            public const string Oracle10g11g = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1}))(CONNECT_DATA=(SERVICE_NAME={2}))); User Id={3};Password={4};";
            public const string Mysql5x = "Server={0};Port={1};Database={2};Uid={3};Pwd={4};";
        }

        public static class Mensages
        {
            public const string ERROR_NO_EXISTE_CONEXION = "No existe conexión";
            public const string ERROR_NO_CREACION_TABLA_PARCHES = "No se pudo crear la tabla de migraciones";
        }

        public static class Dll
        {
            public const string SQL_SERVER = "System.Data.dll";
            public const string POSTGRESQL = "Npgsql.dll";
            public const string Oracle10g11g = "Oracle.DataAccess.dll";
            public const string Mysql5x = "mysql.data.dll";
        }

        public static class DbCommandClass
        {
            public const string SQL_SERVER = "System.Data.SqlClient.SqlCommand";
            public const string POSTGRESQL = "Npgsql.NpgsqlCommand";
            public const string Oracle10g11g = "Oracle.DataAccess.Client.OracleCommand";
            public const string Mysql5x = "MySql.Data.MySqlClient.MySqlCommand";
        }

        public static class DbConection
        {
            public const string SQL_SERVER = "System.Data.SqlClient.SqlConnection";
            public const string POSTGRESQL = "Npgsql.NpgsqlConnection";
            public const string Oracle10g11g = "Oracle.DataAccess.Client.OracleConnection";
            public const string Mysql5x = "MySql.Data.MySqlClient.MySqlConnection";
        }
    }
}
